Geo filtering is not configured
|
| MYSQL ERROR | | Error: | User 'empadmin' has exceeded the 'max_questions' resource (current value: 300000) | | Query: | SELECT COUNT(`T1`.`towns`) AS `Number`, SUM(IF(`T1`.`Category_ID` = '503' OR (FIND_IN_SET('503', `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET('503', `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_503`, `T1`.`towns` FROM `fl_listings` AS `T1` LEFT JOIN `fl_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` LEFT JOIN `fl_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `fl_accounts` AS `T7` ON `T1`.`Account_ID` = `T7`.`ID` LEFT JOIN `fl_currency_rate` AS `CURCONV` ON SUBSTRING_INDEX(`T1`.`towns`, '|', -1) = `CURCONV`.`Key` AND `CURCONV`.`Status` = 'active' WHERE (UNIX_TIMESTAMP(DATE_ADD(`T1`.`Pay_date`, INTERVAL `T2`.`Listing_period` DAY)) > UNIX_TIMESTAMP(NOW()) OR `T2`.`Listing_period` = 0) AND `T1`.`towns` <> '' AND `T1`.`towns` NOT LIKE '%+%' AND `T1`.`Status` = 'active' AND `T3`.`Status` = 'active' AND `T7`.`Status` = 'active' AND `T1`.`towns` <> '0' AND (((`T1`.`Category_ID` = '503' OR (FIND_IN_SET('503', `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET('503', `T3`.`Parent_IDs`) > 0)) AND `T1`.`title` = 'Caribe Hilton Hotel' AND `T1`.`website` = 'www.caribehilton.com' AND `T1`.`b_address` = 'Calle San Gerónimo I' AND `T1`.`b_zip` = '00918' GROUP BY `T1`.`towns` HAVING COUNT(`T1`.`towns`) > 0 ORDER BY `Number` DESC | | Function: | include | | File: | /hermes/bosnacweb04/bosnacweb04bc/b2318/glo.mdprmaster/emp/libs/smarty/Smarty.class.php (line# 1258) |
| |
